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