UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zisvU2pLzrs7Se/nBLzIFZN5Krxj70LHwOYtEeA2aIE='
WHERE
key_id = 'ca9cf84d486e6e39c7e70dc12a9b16a970b1a0cf2ec9cc558169b5a2c93e752c'
AND (
token = 'zisvU2pLzrs7Se/nBLzIFZN5Krxj70LHwOYtEeA2aIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)