UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBr93SDQFYb/CrJ8YrrG2HSRyG8iLIb8RCcUWvyPhGc='
WHERE
key_id = '542337cc8c4d0fdf784e5a1d72548eada9f4bda030d50bc95ffde3981550dccc'
AND (
token = 'pBr93SDQFYb/CrJ8YrrG2HSRyG8iLIb8RCcUWvyPhGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)