UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd3XurisUHXcYpOYNshE0ktxQkGGOc0CBNRCwgrm1jdU='
WHERE
key_id = '9bb2537a631b4ce28b74085f4de4677f7aa95f6ff08df30a95ef50df56e941be'
AND (
token = 'd3XurisUHXcYpOYNshE0ktxQkGGOc0CBNRCwgrm1jdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)