UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZwuL/Wh6IVuBD6j/DI0uussqCPOstSsTv+r7VZqsOc='
WHERE
key_id = 'fbe1d804c07c21db66b3a174ebdb73bee51a8d2d31d409cd8454c83136d5472a'
AND (
token = 'XZwuL/Wh6IVuBD6j/DI0uussqCPOstSsTv+r7VZqsOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)