UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gxG6tZn5KvZROTenhFJQJyBIM3zU+JIGH+pQRYMpoU='
WHERE
key_id = 'fb2e16adfd2bc0ba3342fea2843e0dcbc472820f984b2df24a547c1511251ee4'
AND (
token = '0gxG6tZn5KvZROTenhFJQJyBIM3zU+JIGH+pQRYMpoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)