UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uCA+w3PWPr1aJMmmCHYEMZLQ2PgHdT2/e0xiTlJXtsw='
WHERE
key_id = 'f6b4077ed7edb0ba8babc847a3af9432c39a442f11ab467ec4830d39a55286c5'
AND (
token = 'uCA+w3PWPr1aJMmmCHYEMZLQ2PgHdT2/e0xiTlJXtsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)