UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vAA5oYVQemmZb1YhFjiFE1No07yoVeKWuqbmu8L7eiw='
WHERE
key_id = '5196c9932057d5946eb8a94edb5a633ffe1da5928f753f75668f182ef7355148'
AND (
token = 'vAA5oYVQemmZb1YhFjiFE1No07yoVeKWuqbmu8L7eiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)