UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hFCEg7/Op83bY819rCW17IUFYRV7nBSKBYsgvaE4ybo='
WHERE
key_id = 'cac040399ccd81d02a161b7b43305ad9a9d791dd3db5f591c355236c61125680'
AND (
token = 'hFCEg7/Op83bY819rCW17IUFYRV7nBSKBYsgvaE4ybo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)