UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LV5Crhj7ScAUHwuhQdVc4F/4CKsmH2V0HTiHuYbCryc='
WHERE
key_id = 'c0f057e32739038528aabd27866372fa1cb61a39d57ef8dd0d96540d5910277b'
AND (
token = 'LV5Crhj7ScAUHwuhQdVc4F/4CKsmH2V0HTiHuYbCryc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)