UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gvc6O9noR5q7hKw1Ov/6roa0rqd2iejFBU6OHYnML0s='
WHERE
key_id = '40186b4a2366c09a81a2916ff0b58e255f898fd51b689aa0a114a66b9bbcc6e1'
AND (
token = 'Gvc6O9noR5q7hKw1Ov/6roa0rqd2iejFBU6OHYnML0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)