UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIXYC6JY2MpzWhBVDvg1H2bo81s3EZddeaLs41UfPrA='
WHERE
key_id = '6c1b406e44040b345cb9ddbcf2cd27df91f97e4dea4bc80c52884e0cf56f08e7'
AND (
token = 'XIXYC6JY2MpzWhBVDvg1H2bo81s3EZddeaLs41UfPrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)