UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uEeuCrAcE5ZXkMHYA/LIJVGDc3+cBg5UWEw5ZjPZpMc=' 
WHERE 
  key_id = 'c416d8e6dd0af577124b812317429e85aeb5a1d0bba3cb839b0d2910050d7894' 
  AND (
    token = 'uEeuCrAcE5ZXkMHYA/LIJVGDc3+cBg5UWEw5ZjPZpMc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045