UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1/wHP1wXvRcNcCaIl7cmZJ3kfsrkzGFqbZRndMjiyCE='
WHERE
key_id = '812aef741e8d98adaaa7f31ac0901a5fc0fbee7d0a51029ceecc0a395412ae9c'
AND (
token = '1/wHP1wXvRcNcCaIl7cmZJ3kfsrkzGFqbZRndMjiyCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)