UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r2BxD7tAzHGiKAZeonFStEabSfKVy6Y4uhyZFWQCI5E='
WHERE
key_id = '8e6a6178293c81d1b204b49cd56d35fae8a47d9f2c51eeeb2d5df7fb263d8b2f'
AND (
token = 'r2BxD7tAzHGiKAZeonFStEabSfKVy6Y4uhyZFWQCI5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)