UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcSOU3ZNVODb4VxyhuQMFLauunu/pizxv8PKTJ5h90M='
WHERE
key_id = 'f0f2ab5e8ad317a44ee6e4da618de58c0bf1fc6a319e89c91b2581f87eeda87f'
AND (
token = 'mcSOU3ZNVODb4VxyhuQMFLauunu/pizxv8PKTJ5h90M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)