UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNlEdILHzavaMnQi4HnpiBt3qfX+ex4mZAPTTciNiaI='
WHERE
key_id = 'a5526b67acc9cc067f34bbafcc1494e71943dda168bea58562d6bab1cfa67fc9'
AND (
token = 'ZNlEdILHzavaMnQi4HnpiBt3qfX+ex4mZAPTTciNiaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)