UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xICGe6fGpiqTaDqQhhK/7J5vv4N0J9mTpxVE48ewGpU='
WHERE
key_id = '50371c4b695d762cef55d70c92e63ba8f042c1b4f33b058b3fbc98d25ec72708'
AND (
token = 'xICGe6fGpiqTaDqQhhK/7J5vv4N0J9mTpxVE48ewGpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)