UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJpxtoexbisLkperAL9wGTYYLTWOJtKzSTt/Z5SgkO4='
WHERE
key_id = '2676d4dcc27550e4456ef484a7ae9aa1e779857202f9bbc7c77afde54350e05a'
AND (
token = 'zJpxtoexbisLkperAL9wGTYYLTWOJtKzSTt/Z5SgkO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)