UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4p9lX77zZdx1JSQUqJfLxlPeekRq4e7wy0kfAUZBRWQ='
WHERE
key_id = 'a98f9bda15cccb5d38d1f0498cd854614747685b057c0530635247cbfba22448'
AND (
token = '4p9lX77zZdx1JSQUqJfLxlPeekRq4e7wy0kfAUZBRWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)