UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8aKGnqwKKLILn8TWsfU6ZfRJ1zBAchoktgvI6s/KyHQ='
WHERE
key_id = 'bea143409bec1cf75592277cf5a82951781bf136b8097ecb3823f451f2644cd5'
AND (
token = '8aKGnqwKKLILn8TWsfU6ZfRJ1zBAchoktgvI6s/KyHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)