UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/BXw9JSxeDmeJaMOWK+HZxRSZHer02eUNcKibyqkkj0='
WHERE
key_id = '8a0c433f8f44547076fca3805dd6dc3fae06789b4d84b9c00816776b230d51e0'
AND (
token = '/BXw9JSxeDmeJaMOWK+HZxRSZHer02eUNcKibyqkkj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)