UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'offKxslt1Vo9wgD11JPMH675EEnXz5HBWgbcYkConBY='
WHERE
key_id = 'ef7b86193b7ad2369e6e09a06f644f5166eb91ca0afe3e29ff980cde113b58f6'
AND (
token = 'offKxslt1Vo9wgD11JPMH675EEnXz5HBWgbcYkConBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)