UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xho2fhXkTksANJWfCSEfwYjEvLBOn0IR7H6CKON5hIU='
WHERE
key_id = 'ed15c7dad1d9051ae1f59209cc14cb75c56723a54a3f321cdb58b6184684142e'
AND (
token = 'Xho2fhXkTksANJWfCSEfwYjEvLBOn0IR7H6CKON5hIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)