UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BBlZlehNGs28vu4r8GaYfkN2Hci2tJiyrlUVTXrCF4s='
WHERE
key_id = '8c186f10c576df2beae60cf533295b1a4b347944fe5e26733f49864aab57165c'
AND (
token = 'BBlZlehNGs28vu4r8GaYfkN2Hci2tJiyrlUVTXrCF4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)