UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HJPQsmHiSiCrhFd4gmorSQTHLRf2Caflz/Xv6A5T9G4='
WHERE
key_id = 'a9d4ab46f6ef3bce2d0e27f4dd67b8e6da6ebfdc37dce5f20f63c6c7ed24a090'
AND (
token = 'HJPQsmHiSiCrhFd4gmorSQTHLRf2Caflz/Xv6A5T9G4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)