UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXJjjnUIM9hFoFiHqEzJePwxv14RYjZupLU04N9GP6k='
WHERE
key_id = '81868be88022567bebc144879e8b992cd743da9daa932a1689f9af98789a8e72'
AND (
token = 'qXJjjnUIM9hFoFiHqEzJePwxv14RYjZupLU04N9GP6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)