UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2knfNgqdR9mBAKNb2mUKjT6Z8pEuy5biHmizhCScN9A='
WHERE
key_id = '69a029689407f193ad4fdbd4a5e58bad0387d94ce89365388f1b8fd41616a489'
AND (
token = '2knfNgqdR9mBAKNb2mUKjT6Z8pEuy5biHmizhCScN9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)