UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rZYh/4Ug1OPCgZf589zRJRJhst/litbgrqivrhf2VHo='
WHERE
key_id = '1e5b162520e2e9ab7df70b9a9f452924c3d1c44a71343001e8905980e6979e9b'
AND (
token = 'rZYh/4Ug1OPCgZf589zRJRJhst/litbgrqivrhf2VHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)