UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFsay2hFHQ0wu+HUuAleudwzm6z8L7szGi1wE6szQYY='
WHERE
key_id = 'a48f1dad29370fb1c61d5c10e9d826df411d9e2de38125caae07df1cfa2a4542'
AND (
token = 'XFsay2hFHQ0wu+HUuAleudwzm6z8L7szGi1wE6szQYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)