UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rr7es9L2qBn6ks4jeLw3KDxVaP/4YYxgFpcJV7tkEHk='
WHERE
key_id = 'dfbcdd59b1f17d97341fc8e8e087b699ac45615d7a3e563a01a29930a19dddb9'
AND (
token = 'rr7es9L2qBn6ks4jeLw3KDxVaP/4YYxgFpcJV7tkEHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)