UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SnilSu58nCp2yERS0XxG94DktmS+QK5g6b+p+625b+0=' 
WHERE 
  key_id = '1f493160cda73df508d5e22b191e49a1b8dbed81f952d4e31a30207a9534e96c' 
  AND (
    token = 'SnilSu58nCp2yERS0XxG94DktmS+QK5g6b+p+625b+0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039