UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZT7vwaff7Y4jZeo9hA9UXXHouVg80JS9LI3KjfRHV8s='
WHERE
key_id = '5a281eabe57b7e61ad208c928920e19930946723a66e65d7549516040dd7e056'
AND (
token = 'ZT7vwaff7Y4jZeo9hA9UXXHouVg80JS9LI3KjfRHV8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)