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