UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GUzDvGF2Oalj8am5MWq5DPvDn0hl2WNYbaisNV4+At0='
WHERE
key_id = '2e9195a28b190bf5c862c5b0e189b7175452a60820bb94728c98065ca59d6758'
AND (
token = 'GUzDvGF2Oalj8am5MWq5DPvDn0hl2WNYbaisNV4+At0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)