UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aBZiQ8T3EZLEwpSKadtSwDShE3uenB6uM1W6ANEcrQo='
WHERE
key_id = 'e9bf09119bf4188ff84364066d6b4c23e913943dc59880309d51135fdeeff5b5'
AND (
token = 'aBZiQ8T3EZLEwpSKadtSwDShE3uenB6uM1W6ANEcrQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)