UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kVUi+4HxRC9VqYBH+lrIHwj4ggIl1TKUMpCaODWRPiU='
WHERE
key_id = '27a1e9dc6470adc85278acf1a213e0e266a14cd195866bac13bb8cb6bfc8a6a4'
AND (
token = 'kVUi+4HxRC9VqYBH+lrIHwj4ggIl1TKUMpCaODWRPiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)