UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUmt0Ol2JWHub7uTFPqDsIhVxdKdFtx82Cr8+mtDtc4='
WHERE
key_id = 'd977f164731f9a23ddd0b9c7cabc56ffcda474f5922ba2f2c0a374e03fe7ab70'
AND (
token = 'ZUmt0Ol2JWHub7uTFPqDsIhVxdKdFtx82Cr8+mtDtc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)