UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8bfh8GAa3eLTFMrfAQjheofxA+OlYWpLZkGASPxuhcs='
WHERE
key_id = '4a8e263259e767b63965e82a7cd173a5f04f4163e5d95ca9e8031c755730096e'
AND (
token = '8bfh8GAa3eLTFMrfAQjheofxA+OlYWpLZkGASPxuhcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)