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