UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rxhNTjBEYixxwxLJtGa52mUdBIaf9t6db1WaQfJObM='
WHERE
key_id = '444b31c460df397f30d190256476b2a372768e0b332894985300683e3b9e4e7b'
AND (
token = '9rxhNTjBEYixxwxLJtGa52mUdBIaf9t6db1WaQfJObM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)