UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xGg6WQhfdZ9a2Ts0ym0LTATpYOtPVvmaT3N9A3/ebcY='
WHERE
key_id = 'ca17ec2ea7dfe858f313ca46b99f0093eefbeffc7393f5580b8196f0c6035818'
AND (
token = 'xGg6WQhfdZ9a2Ts0ym0LTATpYOtPVvmaT3N9A3/ebcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)