UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JVIbPtszqiY4QPLsIlo4+Y9J0EowJaTttb0knQgMJQk='
WHERE
key_id = '3c05e3e552c850c5bb539377bed524fb2a121d0d80d85768e2df5527d21ab64b'
AND (
token = 'JVIbPtszqiY4QPLsIlo4+Y9J0EowJaTttb0knQgMJQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)